package com.trkj.dao.cf;

import java.util.List;

import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.CertificateType;
import com.trkj.pojo.ZszlType;
import com.trkj.vo.cf.CertificateTypeVo;

public interface CertificateTypeDAO extends CrudRepository<CertificateType, Long> {
	@Query("select z,c from ZszlType z inner join z.certificateType c where c.certypeName like ?1")
	public List<Object[]> queryBycertypeName(String certypeName,Pageable p);
	//@Query("select z,c from ZszlType z inner join  z.certificates c where z.zszlName like ?1")
	//List<CertificateTypeVo> queryBycertypeName1(Pageable pageRanges,String zszlName);
}
